<?

// Get the Price Data Array---------------------------
$query = mysql_query("SELECT * FROM prices ORDER by id");
	$pDA = array();
	while ($rows = mysql_fetch_assoc($query))
		{	$pDA[$rows['mineral']]=$rows;	}

//Print to Screen Option - remove comment marks
//echo "<pre>";
//print_r($pDA);
//echo "</pre>";

// Get the Ore Data Array ------------------------------
$query = mysql_query("SELECT * FROM ore order by id");
	$oDA = array();
	while ($rows = mysql_fetch_assoc($query))
		{	$oDA[$rows['sn']]=$rows;	}

//Print to Screen Option - remove comment marks
//echo "<pre>";
//print_r($oDA);
//echo "</pre>";


//close all connections 
mysql_close($link);
?>				